{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ポジションサイズの計算","気づき","画像"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ポジションサイズの計算","index":0,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,18,4,19],[4,20,4,21],[3,17,3,20],[0,1,0,6],[3,1,3,5],[3,6,3,10],[3,11,3,13],[3,14,3,16]]}
[null,"EUR/CAD　4時間足　2009年12月～2010月12月"]
[]
[]
[null,"エントリー前",null,null,null,null,"決済後",null,null,null,null,"損益pips",null,null,"損切り幅の計算"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M",1,2,3,null,"エントリー",null,"決済"]
["No","資金","ロスカット","損切り幅","レート","ﾎﾟｼﾞｼｮﾝｻｲｽﾞ","獲得pips","ロット",null,"レート","損益","エントリー","決済","損益","STOP","エントリー","損切り幅","売買","日付","時間","日付","時間"]
[]
[1,500000,0.03,34,96,{"$f":"SUM(B8*C8/D8/E8)","v":4.5955882352941178},-34,4.5,100,0.96,{"$f":"SUM(G8*H8*I8*J8)","v":-14688},1.5688,1.5722,{"$f":"SUM(L8-M8)","v":-3.4000000000000696E-3},1.5722,1.5688,{"$f":"SUM(O8-P8)*10000","v":34.000000000000696},"売","2015-12-07","08:00:00","2015-12-07","12:00:00"]
[2,{"$f":"SUM(B8+K8)","v":485312},0.03,34,96,{"$f":"SUM(B9*C9/D9/E9)","v":4.4605882352941171},18,4.4000000000000004,100,0.96,{"$f":"SUM(G9*H9*I9*J9)","v":7603.2},1.5531999999999999,1.5513999999999999,{"$f":"SUM(L9-M9)","v":1.8000000000000238E-3},1.5566,1.5531999999999999,{"$f":"SUM(O9-P9)*10000","v":34.000000000000696},"売","2015-12-10","08:00:00","2015-12-11","20:00:00"]
[3,492915.20000000001,0.03,61,96,2.5251803278688523,332,2.5,100,0.96,79680,1.5331999999999999,1.5,{"$f":"SUM(L10-M10)","v":3.3199999999999896E-2},1.5392999999999999,1.5331999999999999,60.999999999999943,"売","2015-12-18","12:00:00","2015-12-23","16:00:00"]
[4,572595.19999999995,0.03,45,96,3.9763555555555556,150,3.9,100,0.96,56160,1.492,1.4770000000000001,{"$f":"SUM(L11-M11)","v":1.4999999999999902E-2},1.4964999999999999,1.492,44.999999999999488,"売","2015-01-05","20:00:00","2015-01-08","12:00:00"]
[5,628755.19999999995,0.03,52,96,3.7785769230769226,180,3.7,100,0.96,63936,1.4775,1.4955000000000001,{"$f":"SUM(M12-L12)","v":1.8000000000000016E-2},1.4722999999999999,1.4775,{"$f":"SUM(P12-O12)*10000","v":52.000000000000938},"買","2015-01-21","16:00:00","2015-01-22","20:00:00"]
[6,692691.2,0.03,46,96,4.7057826086956513,521,4.7,100,0.96,235075.20000000001,1.4674,1.4153,{"$f":"SUM(L13-M13)","v":5.2100000000000035E-2},1.472,1.4674,45.999999999999375,"売","2015-02-10","12:00:00","2015-02-23","16:00:00"]
[7,927766.39999999991,0.03,72,96,4.0267638888888877,0,4,100,0.96,0,1.3646,1.3646,{"$f":"SUM(L14-M14)","v":0},1.3717999999999999,1.3646,71.999999999998735,"売","2015-03-24","20:00:00","2015-03-26","08:00:00"]
[8,927766.39999999991,0.03,62,96,{"$f":"SUM(B15*C15/D15/E15)","v":4.67624193548387},409,4.5999999999999996,100,0.96,180614.39999999999,1.2875000000000001,1.3284,{"$f":"SUM(M15-L15)","v":4.0899999999999936E-2},1.2813000000000001,1.2875000000000001,{"$f":"SUM(P15-O15)*10000","v":61.999999999999829},"買","2015-06-30","12:00:00","2015-07-05","08:00:00"]
[9,1108380.7999999998,0.03,46,96,7.5297608695652158,227,7.5,100,0.96,163440,1.3207,1.298,{"$f":"SUM(L16-M16)","v":2.2699999999999942E-2},1.3252999999999999,1.3207,45.999999999999375,"売","2015-07-09","12:00:00","2015-07-13","08:00:00"]
[10,1271820.7999999998,0.03,63,96,6.3086349206349199,833,6.3,100,0.96,503798.39999999997,1.3237000000000001,1.407,{"$f":"SUM(M17-L17)","v":8.329999999999993E-2},1.3173999999999999,1.3237000000000001,{"$f":"SUM(P17-O17)*10000","v":63.000000000001947},"買","2015-09-14","16:00:00","2015-10-05","12:00:00"]
[11,1775619.1999999997,0.03,27,96,20.551148148148144,132,20,100,0.96,253440,1.4196,1.4328000000000001,{"$f":"SUM(M18-L18)","v":1.3200000000000101E-2},1.4169,1.4196,26.999999999999247,"買","2015-10-20","06:00:00","2015-10-25","06:00:00"]
[12,2029059.1999999997,0.03,56,96,11.322874999999998,283,11.3,100,0.96,306998.39999999997,1.3953,1.367,{"$f":"SUM(L19-M19)","v":2.8299999999999992E-2},1.4009,1.3953,56.000000000000497,"売","2015-11-06","12:00:00","2015-11-10","16:00:00"]
[13,2336057.5999999996,0.03,65,96,11.231046153846151,89,11.2,100,0.96,95692.800000000003,1.3891,1.3979999999999999,{"$f":"SUM(M20-L20)","v":8.899999999999908E-3},1.3826000000000001,1.3891,{"$f":"SUM(P20-O20)*10000","v":64.999999999999503},"買","2015-10-18","20:00:00","2015-11-19","12:00:00"]
[14,{"$f":"SUM(B20+K20)","v":2431750.3999999994},0.03,46,96,{"$f":"SUM(B21*C21/D21/E21)","v":16.520043478260863},633,16.5,100,0.96,{"$f":"SUM(G21*H21*I21*J21)","v":1002672},1.3907,1.3273999999999999,{"$f":"SUM(L21-M21)","v":6.3300000000000134E-2},1.3953,1.3907,45.999999999999375,"売","2015-11-22","12:00:00","2015-11-30","12:00:00"]
[15,{"$f":"SUM(B21+K21)","v":3434422.3999999994},0.03,61,96,{"$f":"SUM(B22*C22/D22/E22)","v":17.594377049180324},138,17.5,100,0.96,{"$f":"SUM(G22*H22*I22*J22)","v":231840},1.3394999999999999,1.3257000000000001,{"$f":"SUM(L22-M22)","v":1.3799999999999812E-2},1.3455999999999999,1.3394999999999999,60.999999999999943,"売","2015-12-15","16:00:00","2015-12-15","20:00:00"]
[16,{"$f":"SUM(B22+K22)","v":3666262.3999999994},0.03,64,96,{"$f":"SUM(B23*C23/D23/E23)","v":17.901671874999995},102,17.899999999999999,100,0.96,{"$f":"SUM(G23*H23*I23*J23)","v":175276.79999999999},1.3291999999999999,1.319,{"$f":"SUM(L23-M23)","v":1.0199999999999987E-2},1.3355999999999999,1.3291999999999999,63.999999999999616,"売","2015-12-22","16:00:00","2015-12-24","20:00:00"]

{"sheet":"気づき","index":1,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,6,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,20],[2,18,2,19],[2,20,2,21]]}
[]
[null,"エントリー前",null,null,null,null,"決済後",null,null,null,null,"損益pips",null,null,"損切り幅の計算"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M",1,2,3,null,"エントリー",null,"決済"]
["No","資金","ロスカット","損切り幅","レート","ﾎﾟｼﾞｼｮﾝｻｲｽﾞ","獲得pips","ロット",null,"レート","損益","エントリー","決済","損益","STOP","エントリー","損切り幅","売買","日付","時間","日付","時間"]
[]
[1,500000,0.03,34,96,{"$f":"SUM(B6*C6/D6/E6)","v":4.5955882352941178},-34,4.5,100,0.96,{"$f":"SUM(G6*H6*I6*J6)","v":-14688},1.5688,1.5722,{"$f":"SUM(L6-M6)","v":-3.4000000000000696E-3},1.5722,1.5688,{"$f":"SUM(O6-P6)*10000","v":34.000000000000696},"売","2015-12-07","08:00:00","2015-12-07","12:00:00"]
[2,{"$f":"SUM(B6+K6)","v":485312},0.03,34,96,{"$f":"SUM(B7*C7/D7/E7)","v":4.4605882352941171},18,4.4000000000000004,100,0.96,{"$f":"SUM(G7*H7*I7*J7)","v":7603.2},1.5531999999999999,1.5513999999999999,{"$f":"SUM(L7-M7)","v":1.8000000000000238E-3},1.5566,1.5531999999999999,{"$f":"SUM(O7-P7)*10000","v":34.000000000000696},"売","2015-12-10","08:00:00","2015-12-11","20:00:00"]
[3,492915.20000000001,0.03,61,96,2.5251803278688523,332,2.5,100,0.96,79680,1.5331999999999999,1.5,{"$f":"SUM(L8-M8)","v":3.3199999999999896E-2},1.5392999999999999,1.5331999999999999,60.999999999999943,"売","2015-12-18","12:00:00","2015-12-23","16:00:00"]
[4,572595.19999999995,0.03,45,96,3.9763555555555556,150,3.9,100,0.96,56160,1.492,1.4770000000000001,{"$f":"SUM(L9-M9)","v":1.4999999999999902E-2},1.4964999999999999,1.492,44.999999999999488,"売","2015-01-05","20:00:00","2015-01-08","12:00:00"]
[5,628755.19999999995,0.03,52,96,3.7785769230769226,180,3.7,100,0.96,63936,1.4775,1.4955000000000001,{"$f":"SUM(M10-L10)","v":1.8000000000000016E-2},1.4722999999999999,1.4775,{"$f":"SUM(P10-O10)*10000","v":52.000000000000938},"買","2015-01-21","16:00:00","2015-01-22","20:00:00"]
[6,692691.2,0.03,46,96,4.7057826086956513,521,4.7,100,0.96,235075.20000000001,1.4674,1.4153,{"$f":"SUM(L11-M11)","v":5.2100000000000035E-2},1.472,1.4674,45.999999999999375,"売","2015-02-10","12:00:00","2015-02-23","16:00:00"]
[7,927766.39999999991,0.03,72,96,4.0267638888888877,0,4,100,0.96,0,1.3646,1.3646,{"$f":"SUM(L12-M12)","v":0},1.3717999999999999,1.3646,71.999999999998735,"売","2015-03-24","20:00:00","2015-03-26","08:00:00"]
[8,927766.39999999991,0.03,62,96,4.67624193548387,409,4.5999999999999996,100,0.96,180614.39999999999,1.2875000000000001,1.3284,{"$f":"SUM(M13-L13)","v":4.0899999999999936E-2},1.2813000000000001,1.2875000000000001,{"$f":"SUM(P13-O13)*10000","v":61.999999999999829},"買","2015-06-30","12:00:00","2015-07-05","08:00:00"]
[9,1108380.7999999998,0.03,46,96,7.5297608695652158,227,7.5,100,0.96,163440,1.3207,1.298,{"$f":"SUM(L14-M14)","v":2.2699999999999942E-2},1.3252999999999999,1.3207,45.999999999999375,"売","2015-07-09","12:00:00","2015-07-13","08:00:00"]
[10,1271820.7999999998,0.03,63,96,6.3086349206349199,833,6.3,100,0.96,503798.39999999997,1.3237000000000001,1.407,{"$f":"SUM(M15-L15)","v":8.329999999999993E-2},1.3173999999999999,1.3237000000000001,{"$f":"SUM(P15-O15)*10000","v":63.000000000001947},"買","2015-09-14","16:00:00","2015-10-05","12:00:00"]
[11,1775619.1999999997,0.03,27,96,20.551148148148144,132,20,100,0.96,253440,1.4196,1.4328000000000001,{"$f":"SUM(M16-L16)","v":1.3200000000000101E-2},1.4169,1.4196,26.999999999999247,"買","2015-10-20","06:00:00","2015-10-25","06:00:00"]
[12,2029059.1999999997,0.03,56,96,11.322874999999998,283,11.3,100,0.96,306998.39999999997,1.3953,1.367,{"$f":"SUM(L17-M17)","v":2.8299999999999992E-2},1.4009,1.3953,56.000000000000497,"売","2015-11-06","12:00:00","2015-11-10","16:00:00"]
[13,2336057.5999999996,0.03,65,96,11.231046153846151,89,11.2,100,0.96,95692.800000000003,1.3891,1.3979999999999999,{"$f":"SUM(M18-L18)","v":8.899999999999908E-3},1.3826000000000001,1.3891,{"$f":"SUM(P18-O18)*10000","v":64.999999999999503},"買","2015-10-18","20:00:00","2015-11-19","12:00:00"]
[14,2431750.3999999994,0.03,46,96,16.520043478260863,633,16.5,100,0.96,1002672,1.3907,1.3273999999999999,{"$f":"SUM(L19-M19)","v":6.3300000000000134E-2},1.3953,1.3907,45.999999999999375,"売","2015-11-22","12:00:00","2015-11-30","12:00:00"]
[15,3434422.3999999994,0.03,61,96,17.594377049180324,138,17.5,100,0.96,231840,1.3394999999999999,1.3257000000000001,{"$f":"SUM(L20-M20)","v":1.3799999999999812E-2},1.3455999999999999,1.3394999999999999,60.999999999999943,"売","2015-12-15","16:00:00","2015-12-15","20:00:00"]
[16,3666262.3999999994,0.03,64,96,17.901671874999995,102,17.899999999999999,100,0.96,175276.79999999999,1.3291999999999999,1.319,{"$f":"SUM(L21-M21)","v":1.0199999999999987E-2},1.3355999999999999,1.3291999999999999,63.999999999999616,"売","2015-12-22","16:00:00","2015-12-24","20:00:00"]
[]
[]
["＊2010年の４時間足でのエントリー回数は、１年間で13回であった。"]
[]
["＊トレードを見直してみると、決済が結構曖昧であることがわかった。"]
[]
["　","1.レジサポで決済"]
[null,"2.同値反転での決済"]
[null,"3.トレールでの決済"]
[null,"4.MAから２００pips以上離れた場合の決済"]
[null,"5.長い下ヒゲ、上ヒゲでの決済"]
[]
["＊上記5項目で決済しているが、次回は１のレジサポと３のトレールでの決済に集中したい。"]

{"sheet":"画像","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}